package com.huitone.smspfm.dao.oracle;

import java.util.List;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import com.huitone.smspfm.dao.oracle.entity.MoIns;

public class MoInsDao extends BaseDao<MoIns> {

	@Override
	public List<MoIns> getAllObj() {
		return jdbcTemplate.query("SELECT * FROM " + tableName + " WHERE STATUS = '1' AND SENDPORT IS NOT NULL", new BeanPropertyRowMapper<MoIns>(MoIns.class));
	}
	
	/*public List<MoIns> getObjsOrderBySendPortLength() {
		return jdbcTemplate.query("SELECT * FROM " + tableName + " WHERE STATUS = '1' AND SENDPORT IS NOT NULL ORDER BY LENGTH(SENDPORT) DESC" , new BeanPropertyRowMapper<MoIns>(MoIns.class));
	}*/

}
